|
Amazon Redshift is a hosted data warehouse product, which is part of the larger cloud computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing (MPP) data warehouse ParAccel by Actian.〔(【引用サイトリンク】url=http://www.zdnet.com/amazon-redshift-paraccel-in-costly-appliances-out-7000008111/ )〕 Redshift differs from Amazon's other hosted database offering, Amazon RDS, by being able to handle analytics workloads on large scale datasets stored by a column-oriented DBMS principle. To be able to handle large scale datasets Amazon is making use of massive parallel processing. "Amazon Redshift "is based on PostgreSQL 8.0.2. () PostgreSQL 9.x includes some features that are not supported in Amazon Redshift. In addition, there are important differences between Amazon Redshift SQL and PostgreSQL 8.0.2".〔(【引用サイトリンク】title=Amazon Redshift and PostgreSQL )〕 == BI tools == In principle Amazon Redshift is able to handle all connections from other applications based upon ODBC and JDBC connections.〔(Amazon Redshift cloud based data warehouse service ), Johan Louwers.〕 Amazon has listed a number of business intelligence tools as partners and tested tools.〔(AWS Partner Network - Amazon Redshift Partners ), Amazon.〕 * Actian * Actuate Corporation * Birst * Chartio * ClearStory Data * Dundas Data Visualization * Infor * Jaspersoft * Jreport * Logi Analytics * Looker (Software) * MicroStrategy * Pentaho * Periscope.io * Qlik * Redrock BI * SAS (software) * SiSense * Spotfire * Tableau Software Not included in the list, though capable of connecting to Amazon Redshift, are solutions that are capable of connecting to a database by making use of JDBC or ODBC. 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「Amazon Redshift」の詳細全文を読む スポンサード リンク
|